Saudi Aramco Exploration & Producing Data Warehouse: A Case Study

This paper focuses on the challenges faced when building a data warehouse dealing primarily with scientific or engineering data. Successfully applying data warehousing concepts to an engineering-specific database poses some challenges which vary from the usual textbook examples. This, coupled with the introduction of a new database technology (data warehouse), into a large organization with a mature set of users raised an interesting set of challenges. Some of these are highlighted and discussed using the E&P data warehouse at Saudi Aramco as a case study.